{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import tushare as ts  \n",
    "import pandas as pd  \n",
    "from sqlalchemy import create_engine  \n",
    "import sqlalchemy\n",
    "import mysql.connector\n",
    "try:\n",
    "    conn = mysql.connector.connect(user='diagnose_report', password='launch@1234',\n",
    "                                   host='rm-wz9v9e07mh753tk321o.mysql.rds.aliyuncs.com',\n",
    "                                   database='car_spider')\n",
    "except mysql.connector.Error as err:\n",
    "    if err.errno == errorcode.ER_ACCESS_DENIED_ERROR:\n",
    "        print(\"Something is wrong with your user name or password\")\n",
    "    elif err.errno == errorcode.ER_BAD_DB_ERROR:\n",
    "        print(\"Database does not exist\")\n",
    "    else:\n",
    "        print(err)\n",
    "cursor = conn.cursor()\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_jc\")\n",
    "results = cursor.fetchall()\n",
    "jc = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "cursor.execute(\"select notice_type,brand,curb_weight,Wheelbase,car_length,car_width,car_height,Displacement,power,replace(vin,'/r',','),car_factory from bssoz_notice_suv\")\n",
    "results = cursor.fetchall()\n",
    "suv = pd.DataFrame(results,columns=['notice_type','brand','curb_weight','Wheelbase','car_length','car_width','car_height','Displacement','power','vin','car_factory'])\n",
    "suv = suv.drop([8682,8723,8857,8858,9948,9949,10086,10202,10341,10342,10343,10361,10386])\n",
    "all1 = jc.append(suv)\n",
    "cursor.execute(\"select `factory`,`brand`,`style`,`style_1`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`engine_displacement`,`最大功率[kW]` from car_price_detail\")\n",
    "results = cursor.fetchall()\n",
    "price = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop\")\n",
    "results = cursor.fetchall()\n",
    "price2 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "cursor.execute(\"select `厂商`,`品牌`,`车系`,`车型`,`长×宽×高[mm]`,`轴距[mm]`,`整备质量[kg]`,`排量(mL)`,`最大功率[kW]` from car_price_detail_stop_1\")\n",
    "results = cursor.fetchall()\n",
    "price3 = pd.DataFrame(results,columns=['factory','brand','style','style_1','长×宽×高[mm]','轴距[mm]','整备质量[kg]','engine_displacement','最大功率[kW]'])\n",
    "price = price.append(price2)\n",
    "price = price.append(price3)\n",
    "conn.commit()\n",
    "cursor.close()\n",
    "conn.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "LSG_price = price[(price['brand']=='海马')]\n",
    "\n",
    "\n",
    "\n",
    "all1['3']=all1['vin'].apply(lambda x :x[:3])\n",
    "LSG = all1[(all1['3']=='LH1')|(all1['3']=='LJP')|(all1['3']=='LMV')|(all1['3']=='LSY')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand_x</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand_y</th>\n",
       "      <th>style</th>\n",
       "      <th>factory</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>HMC7168J5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>HMC7168J5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>HMC7168J5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>HMC7168C5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>HMC7168F5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>HMC7168C5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>HMC7168F5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>HMC7168F5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>HMC7168C5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>HMC7168F5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>HMC7168C5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>HMC7168F5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>HMA7152DB4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>HMA7152DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>HMA7152DB4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>HMA7152DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>HMA7152DA4DW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>HMA7152DB4DW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>HMA7152DB4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>HMA7152DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>HMA7152DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>HMA7152DA4W</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>207</th>\n",
       "      <td>HMC7165B3</td>\n",
       "      <td>海马</td>\n",
       "      <td>1330</td>\n",
       "      <td>2607</td>\n",
       "      <td>4466</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1598</td>\n",
       "      <td>85</td>\n",
       "      <td>LH17CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4466x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马3</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>208</th>\n",
       "      <td>HMC7164D4S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>88.2</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>209</th>\n",
       "      <td>HMC7164B4S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>85.8</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>210</th>\n",
       "      <td>HMC7162AE3A</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>70.7</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>HMC7164D4S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>88.2</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>HMC7164D3S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>88.2</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>HMC7164A3S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1648</td>\n",
       "      <td>91</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>HMC7164A4S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1648</td>\n",
       "      <td>91</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>HMC7164B3S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>85.8</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>216</th>\n",
       "      <td>HMC7164B4S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>85.8</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>217</th>\n",
       "      <td>HMC7162AE3A</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>70.7</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>218</th>\n",
       "      <td>HMC7162AE3A</td>\n",
       "      <td>海马</td>\n",
       "      <td>1180</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>70.7</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>219</th>\n",
       "      <td>HMC7165K4H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1598</td>\n",
       "      <td>88.2</td>\n",
       "      <td>LH16CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>220</th>\n",
       "      <td>HMC7185B3H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1839</td>\n",
       "      <td>90</td>\n",
       "      <td>LH16CHAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>221</th>\n",
       "      <td>HMC7185B4H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1839</td>\n",
       "      <td>90</td>\n",
       "      <td>LH16CHAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>222</th>\n",
       "      <td>HMC7165K4H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1598</td>\n",
       "      <td>88.2</td>\n",
       "      <td>LH16CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>223</th>\n",
       "      <td>HMC7165G3H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1598</td>\n",
       "      <td>88.2</td>\n",
       "      <td>LH16CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>HMC7185B3H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1839</td>\n",
       "      <td>90</td>\n",
       "      <td>LH16CHAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225</th>\n",
       "      <td>HMC7185B4H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1839</td>\n",
       "      <td>90</td>\n",
       "      <td>LH16CHAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>226</th>\n",
       "      <td>HMC7165E3H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1648</td>\n",
       "      <td>91</td>\n",
       "      <td>LH16CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>227</th>\n",
       "      <td>HMC7165E4H0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1340</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>1648</td>\n",
       "      <td>91</td>\n",
       "      <td>LH16CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>228</th>\n",
       "      <td>HMC7162AE3B</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>70.7</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>229</th>\n",
       "      <td>HMC7162AE3B</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>70.7</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>HMC7162A4S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1584</td>\n",
       "      <td>73.5</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>HMC7162E3A</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1584</td>\n",
       "      <td>73.5</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>HMC7162A4S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1584</td>\n",
       "      <td>73.5</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>HMC7162</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1584</td>\n",
       "      <td>73.5</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>HMC7162AE3B</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1598</td>\n",
       "      <td>70.7</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>HMC7162E3A</td>\n",
       "      <td>海马</td>\n",
       "      <td>1205</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1584</td>\n",
       "      <td>73.5</td>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>HMC7180</td>\n",
       "      <td>海马</td>\n",
       "      <td>1170</td>\n",
       "      <td>2610</td>\n",
       "      <td>4365</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>1839</td>\n",
       "      <td>90</td>\n",
       "      <td>LH17CHJF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "      <td>2610</td>\n",
       "      <td>4365x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>马自达323</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>237 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      notice_type brand_x curb_weight Wheelbase car_length car_width  \\\n",
       "0     HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "1     HMC7168J5S0      海马        1325      2685       4698      1806   \n",
       "2     HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "3     HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "4     HMC7168J5S0      海马        1325      2685       4698      1806   \n",
       "5     HMC7168J5S0      海马        1325      2685       4698      1806   \n",
       "6     HMC7168C5S0      海马        1325      2685       4698      1806   \n",
       "7     HMC7168F5S0      海马        1325      2685       4698      1806   \n",
       "8     HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "9     HMC7168C5S0      海马        1325      2685       4698      1806   \n",
       "10    HMC7168F5S0      海马        1325      2685       4698      1806   \n",
       "11    HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "12    HMC7168F5S0      海马        1325      2685       4698      1806   \n",
       "13    HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "14    HMC7168C5S0      海马        1325      2685       4698      1806   \n",
       "15    HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "16    HMC7168F5S0      海马        1325      2685       4698      1806   \n",
       "17    HMC7168C5S0      海马        1325      2685       4698      1806   \n",
       "18    HMC7168F5S0      海马        1325      2685       4698      1806   \n",
       "19    HMC7168E5S0      海马        1325      2685       4698      1806   \n",
       "20   HMA7152DB4BW      海马        1435      2730       4700      1802   \n",
       "21   HMA7152DA4BW      海马        1435      2730       4700      1802   \n",
       "22   HMA7152DB4BW      海马        1435      2730       4700      1802   \n",
       "23   HMA7152DA4BW      海马        1435      2730       4700      1802   \n",
       "24   HMA7152DA4DW      海马        1435      2730       4700      1802   \n",
       "25   HMA7152DB4DW      海马        1435      2730       4700      1802   \n",
       "26   HMA7152DB4BW      海马        1435      2730       4700      1802   \n",
       "27   HMA7152DA4BW      海马        1435      2730       4700      1802   \n",
       "28   HMA7152DA4BW      海马        1435      2730       4700      1802   \n",
       "29    HMA7152DA4W      海马        1435      2730       4700      1802   \n",
       "..            ...     ...         ...       ...        ...       ...   \n",
       "207     HMC7165B3      海马        1330      2607       4466      1730   \n",
       "208   HMC7164D4S0      海马        1180      2610       4466      1695   \n",
       "209   HMC7164B4S0      海马        1180      2610       4466      1695   \n",
       "210   HMC7162AE3A      海马        1180      2610       4466      1695   \n",
       "211   HMC7164D4S0      海马        1180      2610       4466      1695   \n",
       "212   HMC7164D3S0      海马        1180      2610       4466      1695   \n",
       "213   HMC7164A3S0      海马        1180      2610       4466      1695   \n",
       "214   HMC7164A4S0      海马        1180      2610       4466      1695   \n",
       "215   HMC7164B3S0      海马        1180      2610       4466      1695   \n",
       "216   HMC7164B4S0      海马        1180      2610       4466      1695   \n",
       "217   HMC7162AE3A      海马        1180      2610       4466      1695   \n",
       "218   HMC7162AE3A      海马        1180      2610       4466      1695   \n",
       "219   HMC7165K4H0      海马        1340      2607       4342      1730   \n",
       "220   HMC7185B3H0      海马        1340      2607       4342      1730   \n",
       "221   HMC7185B4H0      海马        1340      2607       4342      1730   \n",
       "222   HMC7165K4H0      海马        1340      2607       4342      1730   \n",
       "223   HMC7165G3H0      海马        1340      2607       4342      1730   \n",
       "224   HMC7185B3H0      海马        1340      2607       4342      1730   \n",
       "225   HMC7185B4H0      海马        1340      2607       4342      1730   \n",
       "226   HMC7165E3H0      海马        1340      2607       4342      1730   \n",
       "227   HMC7165E4H0      海马        1340      2607       4342      1730   \n",
       "228   HMC7162AE3B      海马        1205      2610       4466      1695   \n",
       "229   HMC7162AE3B      海马        1205      2610       4466      1695   \n",
       "230   HMC7162A4S0      海马        1205      2610       4466      1695   \n",
       "231    HMC7162E3A      海马        1205      2610       4466      1695   \n",
       "232   HMC7162A4S0      海马        1205      2610       4466      1695   \n",
       "233       HMC7162      海马        1205      2610       4466      1695   \n",
       "234   HMC7162AE3B      海马        1205      2610       4466      1695   \n",
       "235    HMC7162E3A      海马        1205      2610       4466      1695   \n",
       "236       HMC7180      海马        1170      2610       4365      1695   \n",
       "\n",
       "    car_height Displacement power                vin car_factory    3 轴距[mm]  \\\n",
       "0         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "1         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "2         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "3         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "4         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "5         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "6         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "7         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "8         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "9         1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "10        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "11        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "12        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "13        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "14        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "15        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "16        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "17        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "18        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "19        1477         1591    92  LH17CKBF×××××××××  一汽海马汽车有限公司  LH1   2685   \n",
       "20        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "21        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "22        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "23        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "24        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "25        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "26        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "27        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "28        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "29        1478         1497   120  LMVAFLFC×××××××××    海马汽车有限公司  LMV   2730   \n",
       "..         ...          ...   ...                ...         ...  ...    ...   \n",
       "207       1474         1598    85  LH17CKAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "208       1410         1598  88.2  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "209       1410         1598  85.8  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "210       1410         1598  70.7  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "211       1410         1598  88.2  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "212       1410         1598  88.2  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "213       1410         1648    91  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "214       1410         1648    91  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "215       1410         1598  85.8  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "216       1410         1598  85.8  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "217       1410         1598  70.7  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "218       1410         1598  70.7  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "219       1474         1598  88.2  LH16CKAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "220       1474         1839    90  LH16CHAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "221       1474         1839    90  LH16CHAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "222       1474         1598  88.2  LH16CKAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "223       1474         1598  88.2  LH16CKAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "224       1474         1839    90  LH16CHAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "225       1474         1839    90  LH16CHAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "226       1474         1648    91  LH16CKAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "227       1474         1648    91  LH16CKAF×××××××××  一汽海马汽车有限公司  LH1   2607   \n",
       "228       1410         1598  70.7  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "229       1410         1598  70.7  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "230       1410         1584  73.5  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "231       1410         1584  73.5  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "232       1410         1584  73.5  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "233       1410         1584  73.5  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "234       1410         1598  70.7  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "235       1410         1584  73.5  LH17CKKF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "236       1410         1839    90  LH17CHJF×××××××××  一汽海马汽车有限公司  LH1   2610   \n",
       "\n",
       "          长×宽×高[mm] brand_y   style  factory  \n",
       "0    4698x1806x1477      海马   福美来F5       19  \n",
       "1    4698x1806x1477      海马   福美来F5       19  \n",
       "2    4698x1806x1477      海马   福美来F5       19  \n",
       "3    4698x1806x1477      海马   福美来F5       19  \n",
       "4    4698x1806x1477      海马   福美来F5       19  \n",
       "5    4698x1806x1477      海马   福美来F5       19  \n",
       "6    4698x1806x1477      海马   福美来F5       19  \n",
       "7    4698x1806x1477      海马   福美来F5       19  \n",
       "8    4698x1806x1477      海马   福美来F5       19  \n",
       "9    4698x1806x1477      海马   福美来F5       19  \n",
       "10   4698x1806x1477      海马   福美来F5       19  \n",
       "11   4698x1806x1477      海马   福美来F5       19  \n",
       "12   4698x1806x1477      海马   福美来F5       19  \n",
       "13   4698x1806x1477      海马   福美来F5       19  \n",
       "14   4698x1806x1477      海马   福美来F5       19  \n",
       "15   4698x1806x1477      海马   福美来F5       19  \n",
       "16   4698x1806x1477      海马   福美来F5       19  \n",
       "17   4698x1806x1477      海马   福美来F5       19  \n",
       "18   4698x1806x1477      海马   福美来F5       19  \n",
       "19   4698x1806x1477      海马   福美来F5       19  \n",
       "20   4700x1802x1478      海马    海马M6       10  \n",
       "21   4700x1802x1478      海马    海马M6       10  \n",
       "22   4700x1802x1478      海马    海马M6       10  \n",
       "23   4700x1802x1478      海马    海马M6       10  \n",
       "24   4700x1802x1478      海马    海马M6       10  \n",
       "25   4700x1802x1478      海马    海马M6       10  \n",
       "26   4700x1802x1478      海马    海马M6       10  \n",
       "27   4700x1802x1478      海马    海马M6       10  \n",
       "28   4700x1802x1478      海马    海马M6       10  \n",
       "29   4700x1802x1478      海马    海马M6       10  \n",
       "..              ...     ...     ...      ...  \n",
       "207  4466x1730x1474      海马     海马3        4  \n",
       "208  4466x1695x1410      海马   福美来F5        3  \n",
       "209  4466x1695x1410      海马   福美来F5        3  \n",
       "210  4466x1695x1410      海马   福美来F5        3  \n",
       "211  4466x1695x1410      海马   福美来F5        3  \n",
       "212  4466x1695x1410      海马   福美来F5        3  \n",
       "213  4466x1695x1410      海马   福美来F5        3  \n",
       "214  4466x1695x1410      海马   福美来F5        3  \n",
       "215  4466x1695x1410      海马   福美来F5        3  \n",
       "216  4466x1695x1410      海马   福美来F5        3  \n",
       "217  4466x1695x1410      海马   福美来F5        3  \n",
       "218  4466x1695x1410      海马   福美来F5        3  \n",
       "219  4342x1730x1474      海马      欢动        6  \n",
       "220  4342x1730x1474      海马      欢动        6  \n",
       "221  4342x1730x1474      海马      欢动        6  \n",
       "222  4342x1730x1474      海马      欢动        6  \n",
       "223  4342x1730x1474      海马      欢动        6  \n",
       "224  4342x1730x1474      海马      欢动        6  \n",
       "225  4342x1730x1474      海马      欢动        6  \n",
       "226  4342x1730x1474      海马      欢动        6  \n",
       "227  4342x1730x1474      海马      欢动        6  \n",
       "228  4466x1695x1410      海马   福美来F5        2  \n",
       "229  4466x1695x1410      海马   福美来F5        2  \n",
       "230  4466x1695x1410      海马   福美来F5        2  \n",
       "231  4466x1695x1410      海马   福美来F5        2  \n",
       "232  4466x1695x1410      海马   福美来F5        2  \n",
       "233  4466x1695x1410      海马   福美来F5        2  \n",
       "234  4466x1695x1410      海马   福美来F5        2  \n",
       "235  4466x1695x1410      海马   福美来F5        2  \n",
       "236  4365x1695x1410      海马  马自达323        2  \n",
       "\n",
       "[237 rows x 17 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price = LSG_price[(LSG_price['长×宽×高[mm]']!='')]\n",
    "LSG_price['curb_weight'] =LSG_price['整备质量[kg]']\n",
    "LSG_price = LSG_price.groupby(['轴距[mm]','长×宽×高[mm]','brand','style','curb_weight'])['factory'].count().reset_index()\n",
    "LSG_price['car_length'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[0])\n",
    "LSG_price['car_width'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[1])\n",
    "LSG_price['car_height'] = LSG_price['长×宽×高[mm]'].apply(lambda x:x.split('x')[2])\n",
    "LSG_price['Wheelbase'] =LSG_price['轴距[mm]']\n",
    "\n",
    "LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "result = LSG.merge(LSG_price,on=['car_length','car_width','Wheelbase','car_height','curb_weight'])\n",
    "import re\n",
    "vin1 = []\n",
    "for a,i in result.iterrows():\n",
    "    a = re.findall(r'L[0-9A-Za-z]{7}×××××××××',i['vin'])\n",
    "    for j in a:\n",
    "        vin = []\n",
    "        vin.append(j)\n",
    "        vin.append(i['car_factory'].split(',')[0])\n",
    "        vin.append(i['brand_y'].split(',')[0])\n",
    "        vin.append(i['style'].split(',')[0])\n",
    "        vin1.append(vin)\n",
    "vin = pd.DataFrame(vin1,columns=['vin','car_factory','brand','style'])\n",
    "vin = vin.drop_duplicates()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马轿车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>LMVAFLFD×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>LMVAFLFD×××××××××</td>\n",
       "      <td>海马轿车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>LH17EKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>LH17CHCF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>LH16CHAL×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>LMVAFLEC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>LMVAFLEC×××××××××</td>\n",
       "      <td>海马轿车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>149</th>\n",
       "      <td>LH16CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>159</th>\n",
       "      <td>LH17CKJF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海福星</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>LH17C2JF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海福星</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>LH17CKKF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>LH16CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>LH16CHAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>LH17CHAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>LH17CKAF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>LH17CHJF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>海马</td>\n",
       "      <td>马自达323</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   vin car_factory brand   style\n",
       "0    LH17CKBF×××××××××  一汽海马汽车有限公司    海马   福美来F5\n",
       "20   LMVAFLFC×××××××××    海马汽车有限公司    海马    海马M6\n",
       "32   LMVAFLFC×××××××××    海马轿车有限公司    海马    海马M6\n",
       "40   LMVAFLFD×××××××××    海马汽车有限公司    海马    海马M6\n",
       "49   LMVAFLFD×××××××××    海马轿车有限公司    海马    海马M6\n",
       "55   LH17EKBF×××××××××  一汽海马汽车有限公司    海马   福美来F5\n",
       "69   LH17CHCF×××××××××  一汽海马汽车有限公司    海马    海马M8\n",
       "89   LH16CHAL×××××××××  一汽海马汽车有限公司    海马    海马S7\n",
       "92   LMVAFLEC×××××××××    海马汽车有限公司    海马    海马M3\n",
       "100  LMVAFLEC×××××××××    海马轿车有限公司    海马    海马M3\n",
       "149  LH16CKKF×××××××××  一汽海马汽车有限公司    海马   福美来F5\n",
       "159  LH17CKJF×××××××××  一汽海马汽车有限公司    海马     海福星\n",
       "160  LH17C2JF×××××××××  一汽海马汽车有限公司    海马     海福星\n",
       "163  LH17CKKF×××××××××  一汽海马汽车有限公司    海马   福美来F5\n",
       "170  LH16CKAF×××××××××  一汽海马汽车有限公司    海马      欢动\n",
       "172  LH16CHAF×××××××××  一汽海马汽车有限公司    海马      欢动\n",
       "180  LH17CHAF×××××××××  一汽海马汽车有限公司    海马     海马3\n",
       "181  LH17CKAF×××××××××  一汽海马汽车有限公司    海马     海马3\n",
       "236  LH17CHJF×××××××××  一汽海马汽车有限公司    海马  马自达323"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vin"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "vin.to_csv('海马_VIN.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>notice_type</th>\n",
       "      <th>brand</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>Wheelbase</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Displacement</th>\n",
       "      <th>power</th>\n",
       "      <th>vin</th>\n",
       "      <th>car_factory</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>SY7150B4ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1365</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBBCF×××××××××,LSYYBBDF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>SY7150B2ZBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1325</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBBCB×××××××××,LSYYBBDB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>SY7150B2SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1280</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>82</td>\n",
       "      <td>LSYYBACB×××××××××,LSYYBADB×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>SY7150B4SBAH</td>\n",
       "      <td>中华</td>\n",
       "      <td>1335</td>\n",
       "      <td>2660</td>\n",
       "      <td>4640</td>\n",
       "      <td>1790</td>\n",
       "      <td>1445</td>\n",
       "      <td>1498</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYYBACF×××××××××,LSYYBADF×××××××××</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>206</th>\n",
       "      <td>HMA7120AA3AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1460</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1196</td>\n",
       "      <td>109</td>\n",
       "      <td>LMVAEEFB×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>HMA7150AA4AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1432</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAEEFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>HMA7120AB3AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1490</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1196</td>\n",
       "      <td>109</td>\n",
       "      <td>LMVAEEFB×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>HMA7150AB4AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1455</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAEEFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>345</th>\n",
       "      <td>HMA7160AA4AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1380</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1591</td>\n",
       "      <td>90</td>\n",
       "      <td>LMVAEEFD×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>358</th>\n",
       "      <td>HMC7158B5S1</td>\n",
       "      <td>海马</td>\n",
       "      <td>1390</td>\n",
       "      <td>2700</td>\n",
       "      <td>4713</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1497</td>\n",
       "      <td>115</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>364</th>\n",
       "      <td>HMC7168E5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>487</th>\n",
       "      <td>HMA7152DB4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>489</th>\n",
       "      <td>HMA7152DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>490</th>\n",
       "      <td>HMA7160DA4CW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1330</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1591</td>\n",
       "      <td>86.5</td>\n",
       "      <td>LMVAFLFD×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>494</th>\n",
       "      <td>HMA7160DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1330</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1591</td>\n",
       "      <td>86.5</td>\n",
       "      <td>LMVAFLFD×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>533</th>\n",
       "      <td>HMA7120AA3AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1460</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1196</td>\n",
       "      <td>109</td>\n",
       "      <td>LMVAEEFB×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>551</th>\n",
       "      <td>HMA7150AA4AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1432</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAEEFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>553</th>\n",
       "      <td>HMA7160GB4W</td>\n",
       "      <td>海马</td>\n",
       "      <td>1321</td>\n",
       "      <td>2560</td>\n",
       "      <td>4195</td>\n",
       "      <td>1765</td>\n",
       "      <td>1625,1637</td>\n",
       "      <td>1591</td>\n",
       "      <td>90</td>\n",
       "      <td>LMVHDEED×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>564</th>\n",
       "      <td>HMA7150AB4AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1455</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAEEFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>618</th>\n",
       "      <td>HMC7168E5S1</td>\n",
       "      <td>海马</td>\n",
       "      <td>1390</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>77</td>\n",
       "      <td>LH17EKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>621</th>\n",
       "      <td>HMC7168E5S2</td>\n",
       "      <td>海马</td>\n",
       "      <td>1390</td>\n",
       "      <td>2700</td>\n",
       "      <td>4713</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>77</td>\n",
       "      <td>LH17EKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>630</th>\n",
       "      <td>HMC7168J5S1</td>\n",
       "      <td>海马</td>\n",
       "      <td>1325</td>\n",
       "      <td>2700</td>\n",
       "      <td>4713</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1591</td>\n",
       "      <td>92</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>640</th>\n",
       "      <td>HMC7158B5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1390</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1497</td>\n",
       "      <td>115</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>694</th>\n",
       "      <td>SY7150E4ZBAC</td>\n",
       "      <td>中华</td>\n",
       "      <td>1395,1415,1420</td>\n",
       "      <td>2700</td>\n",
       "      <td>4708,4740</td>\n",
       "      <td>1788</td>\n",
       "      <td>1475</td>\n",
       "      <td>1498</td>\n",
       "      <td>100</td>\n",
       "      <td>LSYYBBCC×××××××××,LSYYBBDC×××××××××,LSYYBBCF××...</td>\n",
       "      <td>华晨汽车集团控股有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>HMC7158B5S0</td>\n",
       "      <td>海马</td>\n",
       "      <td>1390</td>\n",
       "      <td>2685</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>1497</td>\n",
       "      <td>115</td>\n",
       "      <td>LH17CKBF×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>HMA7120AB3AW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1490</td>\n",
       "      <td>2630</td>\n",
       "      <td>4418</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>1196</td>\n",
       "      <td>109</td>\n",
       "      <td>LMVAEEFB×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>807</th>\n",
       "      <td>HMA7152DB4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>808</th>\n",
       "      <td>HMA7152DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1435</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1497</td>\n",
       "      <td>120</td>\n",
       "      <td>LMVAFLFC×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>HMA7160DA4CW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1330</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1591</td>\n",
       "      <td>86.5</td>\n",
       "      <td>LMVAFLFD×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>HMA7160DA4BW</td>\n",
       "      <td>海马</td>\n",
       "      <td>1330</td>\n",
       "      <td>2730</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>1591</td>\n",
       "      <td>86.5</td>\n",
       "      <td>LMVAFLFD×××××××××</td>\n",
       "      <td>海马汽车有限公司</td>\n",
       "      <td>LMV</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10396</th>\n",
       "      <td>SY6470DS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>90</td>\n",
       "      <td>LSYBCAH8×××××××××\\r,LSYBSAH8×××××××××\\r,LSYAAA...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10397</th>\n",
       "      <td>SY6520ES2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5160</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2693</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYBCAFJ×××××××××\\r,LSYBLAFJ×××××××××\\r,LSYAAA...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10398</th>\n",
       "      <td>SY6470EZ</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2693</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYBCBHJ×××××××××\\r,LSYBSBHJ×××××××××\\r,LSYAAB...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10400</th>\n",
       "      <td>SY6491-ME</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1600</td>\n",
       "      <td>3025</td>\n",
       "      <td>5165</td>\n",
       "      <td>1800</td>\n",
       "      <td>1780,1790,1935</td>\n",
       "      <td>2237</td>\n",
       "      <td>76</td>\n",
       "      <td>LSY9SACF×××××××××\\r,LSYAAAAA×××××××××</td>\n",
       "      <td>沈阳金杯车辆制造有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10401</th>\n",
       "      <td>SY6471ES</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715,4790</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2693</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYBCAHJ×××××××××\\r,LSYBSAHJ×××××××××\\r,LSYAAA...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10404</th>\n",
       "      <td>SY6471CS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4790</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2693</td>\n",
       "      <td>105</td>\n",
       "      <td>LSYBCAHH×××××××××\\r,LSYBSAHH×××××××××\\r,LSYAAA...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10405</th>\n",
       "      <td>SY6521CS2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2693</td>\n",
       "      <td>105</td>\n",
       "      <td>LSYBCAFH×××××××××\\r,LSYBLAFH×××××××××\\r,LSYAAA...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10406</th>\n",
       "      <td>SY6471DS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4790</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>90</td>\n",
       "      <td>LSYAAAAB×××××××××\\rLSYAAABB×××××××××\\rLSYAAACB...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10407</th>\n",
       "      <td>SY6471EZ</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4790</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2693</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYAABBF×××××××××\\rLSYAABAF×××××××××\\rLSYAABCF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10408</th>\n",
       "      <td>SY6521DS2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980,1840</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2438</td>\n",
       "      <td>90</td>\n",
       "      <td>LSYAAABB×××××××××\\rLSYAAAAB×××××××××\\rLSYAAACB...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10409</th>\n",
       "      <td>SY6521ES2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2693</td>\n",
       "      <td>110</td>\n",
       "      <td>LSYAAABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAACF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10410</th>\n",
       "      <td>SY6470KS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10411</th>\n",
       "      <td>SY6521KS2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10413</th>\n",
       "      <td>SY6521CS1</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2693</td>\n",
       "      <td>105</td>\n",
       "      <td>LSYAAAAF×××××××××\\rLSYAAABF×××××××××\\rLSYAAACF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10414</th>\n",
       "      <td>SY6521DS1</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980,1840</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2438</td>\n",
       "      <td>90</td>\n",
       "      <td>LSYAAABB×××××××××\\rLSYAAAAB×××××××××\\rLSYAAACB...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10415</th>\n",
       "      <td>SY6521CZ1</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2693</td>\n",
       "      <td>105</td>\n",
       "      <td>LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10416</th>\n",
       "      <td>SY6521CZ2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2693</td>\n",
       "      <td>105</td>\n",
       "      <td>LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10421</th>\n",
       "      <td>SY6521KZ2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10422</th>\n",
       "      <td>SY6471KZ</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4790</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10425</th>\n",
       "      <td>SY6471NS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4790</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2237</td>\n",
       "      <td>76</td>\n",
       "      <td>LSYAAAAA××××××××× LSYAAABA××××××××× LSYAAACA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10426</th>\n",
       "      <td>SY6521NS2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2237</td>\n",
       "      <td>76</td>\n",
       "      <td>LSYAAAAA××××××××× LSYAAABA××××××××× LSYAAACA××...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10430</th>\n",
       "      <td>SY6521KS1</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYAAAAF×××××××××\\rLSYAAABF×××××××××\\rLSYAAACF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10437</th>\n",
       "      <td>SY6471KS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4790</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10453</th>\n",
       "      <td>ZQ6482W2G</td>\n",
       "      <td>奥路卡</td>\n",
       "      <td>1690</td>\n",
       "      <td>2950</td>\n",
       "      <td>5170</td>\n",
       "      <td>1830</td>\n",
       "      <td>1715</td>\n",
       "      <td>2388</td>\n",
       "      <td>110</td>\n",
       "      <td>LJPMFW22×××××××××</td>\n",
       "      <td>郑州轻型汽车制造厂</td>\n",
       "      <td>LJP</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10493</th>\n",
       "      <td>HMC6446A4</td>\n",
       "      <td>海马</td>\n",
       "      <td>1350</td>\n",
       "      <td>2670</td>\n",
       "      <td>4384</td>\n",
       "      <td>1718</td>\n",
       "      <td>1609,1579</td>\n",
       "      <td>1648</td>\n",
       "      <td>91</td>\n",
       "      <td>LH16CKH0×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10494</th>\n",
       "      <td>HMC6446A3</td>\n",
       "      <td>海马</td>\n",
       "      <td>1350</td>\n",
       "      <td>2670</td>\n",
       "      <td>4384</td>\n",
       "      <td>1718</td>\n",
       "      <td>1609,1579</td>\n",
       "      <td>1648</td>\n",
       "      <td>91</td>\n",
       "      <td>LH16CKH0×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10495</th>\n",
       "      <td>SY6521KS2</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1980</td>\n",
       "      <td>3430</td>\n",
       "      <td>5235</td>\n",
       "      <td>1800</td>\n",
       "      <td>1980</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10497</th>\n",
       "      <td>SY6470KS</td>\n",
       "      <td>金杯</td>\n",
       "      <td>1900</td>\n",
       "      <td>2985</td>\n",
       "      <td>4715</td>\n",
       "      <td>1800</td>\n",
       "      <td>1970</td>\n",
       "      <td>2438</td>\n",
       "      <td>102</td>\n",
       "      <td>LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...</td>\n",
       "      <td>沈阳华晨金杯汽车有限公司</td>\n",
       "      <td>LSY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10499</th>\n",
       "      <td>HMC6445A4</td>\n",
       "      <td>海马</td>\n",
       "      <td>1360</td>\n",
       "      <td>2670</td>\n",
       "      <td>4384</td>\n",
       "      <td>1718</td>\n",
       "      <td>1609,1579</td>\n",
       "      <td>1839</td>\n",
       "      <td>90</td>\n",
       "      <td>LH16CHH0×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10500</th>\n",
       "      <td>HMC6445A3</td>\n",
       "      <td>海马</td>\n",
       "      <td>1360</td>\n",
       "      <td>2670</td>\n",
       "      <td>4384</td>\n",
       "      <td>1718</td>\n",
       "      <td>1609,1579</td>\n",
       "      <td>1839</td>\n",
       "      <td>90</td>\n",
       "      <td>LH16CHH0×××××××××</td>\n",
       "      <td>一汽海马汽车有限公司</td>\n",
       "      <td>LH1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1362 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        notice_type brand     curb_weight Wheelbase car_length car_width  \\\n",
       "23     SY7150B4ZBAH    中华            1365      2660       4640      1790   \n",
       "107    SY7150B2ZBAH    中华            1325      2660       4640      1790   \n",
       "108    SY7150B2SBAH    中华            1280      2660       4640      1790   \n",
       "111    SY7150B4SBAH    中华            1335      2660       4640      1790   \n",
       "206    HMA7120AA3AW    海马            1460      2630       4418      1823   \n",
       "212    HMA7150AA4AW    海马            1432      2630       4418      1823   \n",
       "231    HMA7120AB3AW    海马            1490      2630       4418      1823   \n",
       "232    HMA7150AB4AW    海马            1455      2630       4418      1823   \n",
       "345    HMA7160AA4AW    海马            1380      2630       4418      1823   \n",
       "358     HMC7158B5S1    海马            1390      2700       4713      1806   \n",
       "364     HMC7168E5S0    海马            1325      2685       4698      1806   \n",
       "487    HMA7152DB4BW    海马            1435      2730       4700      1802   \n",
       "489    HMA7152DA4BW    海马            1435      2730       4700      1802   \n",
       "490    HMA7160DA4CW    海马            1330      2730       4700      1802   \n",
       "494    HMA7160DA4BW    海马            1330      2730       4700      1802   \n",
       "533    HMA7120AA3AW    海马            1460      2630       4418      1823   \n",
       "551    HMA7150AA4AW    海马            1432      2630       4418      1823   \n",
       "553     HMA7160GB4W    海马            1321      2560       4195      1765   \n",
       "564    HMA7150AB4AW    海马            1455      2630       4418      1823   \n",
       "618     HMC7168E5S1    海马            1390      2685       4698      1806   \n",
       "621     HMC7168E5S2    海马            1390      2700       4713      1806   \n",
       "630     HMC7168J5S1    海马            1325      2700       4713      1806   \n",
       "640     HMC7158B5S0    海马            1390      2685       4698      1806   \n",
       "694    SY7150E4ZBAC    中华  1395,1415,1420      2700  4708,4740      1788   \n",
       "767     HMC7158B5S0    海马            1390      2685       4698      1806   \n",
       "775    HMA7120AB3AW    海马            1490      2630       4418      1823   \n",
       "807    HMA7152DB4BW    海马            1435      2730       4700      1802   \n",
       "808    HMA7152DA4BW    海马            1435      2730       4700      1802   \n",
       "809    HMA7160DA4CW    海马            1330      2730       4700      1802   \n",
       "810    HMA7160DA4BW    海马            1330      2730       4700      1802   \n",
       "...             ...   ...             ...       ...        ...       ...   \n",
       "10396      SY6470DS    金杯            1900      2985       4715      1800   \n",
       "10397     SY6520ES2    金杯            1980      3430       5160      1800   \n",
       "10398      SY6470EZ    金杯            1900      2985       4715      1800   \n",
       "10400     SY6491-ME    金杯            1600      3025       5165      1800   \n",
       "10401      SY6471ES    金杯            1900      2985  4715,4790      1800   \n",
       "10404      SY6471CS    金杯            1900      2985       4790      1800   \n",
       "10405     SY6521CS2    金杯            1980      3430       5235      1800   \n",
       "10406      SY6471DS    金杯            1900      2985       4790      1800   \n",
       "10407      SY6471EZ    金杯            1900      2985       4790      1800   \n",
       "10408     SY6521DS2    金杯       1980,1840      3430       5235      1800   \n",
       "10409     SY6521ES2    金杯            1980      3430       5235      1800   \n",
       "10410      SY6470KS    金杯            1900      2985       4715      1800   \n",
       "10411     SY6521KS2    金杯            1980      3430       5235      1800   \n",
       "10413     SY6521CS1    金杯            1980      3430       5235      1800   \n",
       "10414     SY6521DS1    金杯       1980,1840      3430       5235      1800   \n",
       "10415     SY6521CZ1    金杯            1980      3430       5235      1800   \n",
       "10416     SY6521CZ2    金杯            1980      3430       5235      1800   \n",
       "10421     SY6521KZ2    金杯            1980      3430       5235      1800   \n",
       "10422      SY6471KZ    金杯            1900      2985       4790      1800   \n",
       "10425      SY6471NS    金杯            1900      2985       4790      1800   \n",
       "10426     SY6521NS2    金杯            1900      3430       5235      1800   \n",
       "10430     SY6521KS1    金杯            1980      3430       5235      1800   \n",
       "10437      SY6471KS    金杯            1900      2985       4790      1800   \n",
       "10453     ZQ6482W2G   奥路卡            1690      2950       5170      1830   \n",
       "10493     HMC6446A4    海马            1350      2670       4384      1718   \n",
       "10494     HMC6446A3    海马            1350      2670       4384      1718   \n",
       "10495     SY6521KS2    金杯            1980      3430       5235      1800   \n",
       "10497      SY6470KS    金杯            1900      2985       4715      1800   \n",
       "10499     HMC6445A4    海马            1360      2670       4384      1718   \n",
       "10500     HMC6445A3    海马            1360      2670       4384      1718   \n",
       "\n",
       "           car_height Displacement power  \\\n",
       "23               1445         1498   110   \n",
       "107              1445         1498    82   \n",
       "108              1445         1498    82   \n",
       "111              1445         1498   110   \n",
       "206              1630         1196   109   \n",
       "212              1630         1497   120   \n",
       "231              1630         1196   109   \n",
       "232              1630         1497   120   \n",
       "345              1630         1591    90   \n",
       "358              1477         1497   115   \n",
       "364              1477         1591    92   \n",
       "487              1478         1497   120   \n",
       "489              1478         1497   120   \n",
       "490              1478         1591  86.5   \n",
       "494              1478         1591  86.5   \n",
       "533              1630         1196   109   \n",
       "551              1630         1497   120   \n",
       "553         1625,1637         1591    90   \n",
       "564              1630         1497   120   \n",
       "618              1477         1591    77   \n",
       "621              1477         1591    77   \n",
       "630              1477         1591    92   \n",
       "640              1477         1497   115   \n",
       "694              1475         1498   100   \n",
       "767              1477         1497   115   \n",
       "775              1630         1196   109   \n",
       "807              1478         1497   120   \n",
       "808              1478         1497   120   \n",
       "809              1478         1591  86.5   \n",
       "810              1478         1591  86.5   \n",
       "...               ...          ...   ...   \n",
       "10396            1970         2438    90   \n",
       "10397            1980         2693   110   \n",
       "10398            1970         2693   110   \n",
       "10400  1780,1790,1935         2237    76   \n",
       "10401            1970         2693   110   \n",
       "10404            1970         2693   105   \n",
       "10405            1980         2693   105   \n",
       "10406            1970         2438    90   \n",
       "10407            1970         2693   110   \n",
       "10408            1980         2438    90   \n",
       "10409            1980         2693   110   \n",
       "10410            1970         2438   102   \n",
       "10411            1980         2438   102   \n",
       "10413            1980         2693   105   \n",
       "10414            1980         2438    90   \n",
       "10415            1980         2693   105   \n",
       "10416            1980         2693   105   \n",
       "10421            1980         2438   102   \n",
       "10422            1970         2438   102   \n",
       "10425            1970         2237    76   \n",
       "10426            1980         2237    76   \n",
       "10430            1980         2438   102   \n",
       "10437            1970         2438   102   \n",
       "10453            1715         2388   110   \n",
       "10493       1609,1579         1648    91   \n",
       "10494       1609,1579         1648    91   \n",
       "10495            1980         2438   102   \n",
       "10497            1970         2438   102   \n",
       "10499       1609,1579         1839    90   \n",
       "10500       1609,1579         1839    90   \n",
       "\n",
       "                                                     vin   car_factory    3  \n",
       "23                   LSYYBBCF×××××××××,LSYYBBDF×××××××××  华晨汽车集团控股有限公司  LSY  \n",
       "107                  LSYYBBCB×××××××××,LSYYBBDB×××××××××  华晨汽车集团控股有限公司  LSY  \n",
       "108                  LSYYBACB×××××××××,LSYYBADB×××××××××  华晨汽车集团控股有限公司  LSY  \n",
       "111                  LSYYBACF×××××××××,LSYYBADF×××××××××  华晨汽车集团控股有限公司  LSY  \n",
       "206                                    LMVAEEFB×××××××××      海马汽车有限公司  LMV  \n",
       "212                                    LMVAEEFC×××××××××      海马汽车有限公司  LMV  \n",
       "231                                    LMVAEEFB×××××××××      海马汽车有限公司  LMV  \n",
       "232                                    LMVAEEFC×××××××××      海马汽车有限公司  LMV  \n",
       "345                                    LMVAEEFD×××××××××      海马汽车有限公司  LMV  \n",
       "358                                    LH17CKBF×××××××××    一汽海马汽车有限公司  LH1  \n",
       "364                                    LH17CKBF×××××××××    一汽海马汽车有限公司  LH1  \n",
       "487                                    LMVAFLFC×××××××××      海马汽车有限公司  LMV  \n",
       "489                                    LMVAFLFC×××××××××      海马汽车有限公司  LMV  \n",
       "490                                    LMVAFLFD×××××××××      海马汽车有限公司  LMV  \n",
       "494                                    LMVAFLFD×××××××××      海马汽车有限公司  LMV  \n",
       "533                                    LMVAEEFB×××××××××      海马汽车有限公司  LMV  \n",
       "551                                    LMVAEEFC×××××××××      海马汽车有限公司  LMV  \n",
       "553                                    LMVHDEED×××××××××      海马汽车有限公司  LMV  \n",
       "564                                    LMVAEEFC×××××××××      海马汽车有限公司  LMV  \n",
       "618                                    LH17EKBF×××××××××    一汽海马汽车有限公司  LH1  \n",
       "621                                    LH17EKBF×××××××××    一汽海马汽车有限公司  LH1  \n",
       "630                                    LH17CKBF×××××××××    一汽海马汽车有限公司  LH1  \n",
       "640                                    LH17CKBF×××××××××    一汽海马汽车有限公司  LH1  \n",
       "694    LSYYBBCC×××××××××,LSYYBBDC×××××××××,LSYYBBCF××...  华晨汽车集团控股有限公司  LSY  \n",
       "767                                    LH17CKBF×××××××××    一汽海马汽车有限公司  LH1  \n",
       "775                                    LMVAEEFB×××××××××      海马汽车有限公司  LMV  \n",
       "807                                    LMVAFLFC×××××××××      海马汽车有限公司  LMV  \n",
       "808                                    LMVAFLFC×××××××××      海马汽车有限公司  LMV  \n",
       "809                                    LMVAFLFD×××××××××      海马汽车有限公司  LMV  \n",
       "810                                    LMVAFLFD×××××××××      海马汽车有限公司  LMV  \n",
       "...                                                  ...           ...  ...  \n",
       "10396  LSYBCAH8×××××××××\\r,LSYBSAH8×××××××××\\r,LSYAAA...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10397  LSYBCAFJ×××××××××\\r,LSYBLAFJ×××××××××\\r,LSYAAA...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10398  LSYBCBHJ×××××××××\\r,LSYBSBHJ×××××××××\\r,LSYAAB...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10400              LSY9SACF×××××××××\\r,LSYAAAAA×××××××××  沈阳金杯车辆制造有限公司  LSY  \n",
       "10401  LSYBCAHJ×××××××××\\r,LSYBSAHJ×××××××××\\r,LSYAAA...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10404  LSYBCAHH×××××××××\\r,LSYBSAHH×××××××××\\r,LSYAAA...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10405  LSYBCAFH×××××××××\\r,LSYBLAFH×××××××××\\r,LSYAAA...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10406  LSYAAAAB×××××××××\\rLSYAAABB×××××××××\\rLSYAAACB...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10407  LSYAABBF×××××××××\\rLSYAABAF×××××××××\\rLSYAABCF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10408  LSYAAABB×××××××××\\rLSYAAAAB×××××××××\\rLSYAAACB...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10409  LSYAAABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAACF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10410  LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10411  LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10413  LSYAAAAF×××××××××\\rLSYAAABF×××××××××\\rLSYAAACF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10414  LSYAAABB×××××××××\\rLSYAAAAB×××××××××\\rLSYAAACB...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10415  LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10416  LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10421  LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10422  LSYAABAF×××××××××\\rLSYAABBF×××××××××\\rLSYAABCF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10425  LSYAAAAA××××××××× LSYAAABA××××××××× LSYAAACA××...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10426  LSYAAAAA××××××××× LSYAAABA××××××××× LSYAAACA××...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10430  LSYAAAAF×××××××××\\rLSYAAABF×××××××××\\rLSYAAACF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10437  LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10453                                  LJPMFW22×××××××××     郑州轻型汽车制造厂  LJP  \n",
       "10493                                  LH16CKH0×××××××××    一汽海马汽车有限公司  LH1  \n",
       "10494                                  LH16CKH0×××××××××    一汽海马汽车有限公司  LH1  \n",
       "10495  LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10497  LSYACABF×××××××××\\rLSYAAAAF×××××××××\\rLSYAAABF...  沈阳华晨金杯汽车有限公司  LSY  \n",
       "10499                                  LH16CHH0×××××××××    一汽海马汽车有限公司  LH1  \n",
       "10500                                  LH16CHH0×××××××××    一汽海马汽车有限公司  LH1  \n",
       "\n",
       "[1362 rows x 12 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>轴距[mm]</th>\n",
       "      <th>长×宽×高[mm]</th>\n",
       "      <th>brand</th>\n",
       "      <th>style</th>\n",
       "      <th>curb_weight</th>\n",
       "      <th>factory</th>\n",
       "      <th>car_length</th>\n",
       "      <th>car_width</th>\n",
       "      <th>car_height</th>\n",
       "      <th>Wheelbase</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2332</td>\n",
       "      <td>3590x1540x1486</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马王子</td>\n",
       "      <td>895</td>\n",
       "      <td>6</td>\n",
       "      <td>3590</td>\n",
       "      <td>1540</td>\n",
       "      <td>1486</td>\n",
       "      <td>2332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2332</td>\n",
       "      <td>3590x1540x1518</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马王子</td>\n",
       "      <td>895</td>\n",
       "      <td>6</td>\n",
       "      <td>3590</td>\n",
       "      <td>1540</td>\n",
       "      <td>1518</td>\n",
       "      <td>2332</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2333</td>\n",
       "      <td>3662x1540x1495</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马爱尚</td>\n",
       "      <td>888</td>\n",
       "      <td>6</td>\n",
       "      <td>3662</td>\n",
       "      <td>1540</td>\n",
       "      <td>1495</td>\n",
       "      <td>2333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2333</td>\n",
       "      <td>3662x1540x1503</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马爱尚</td>\n",
       "      <td>888</td>\n",
       "      <td>2</td>\n",
       "      <td>3662</td>\n",
       "      <td>1540</td>\n",
       "      <td>1503</td>\n",
       "      <td>2333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2515</td>\n",
       "      <td>3836x1566x1865</td>\n",
       "      <td>海马</td>\n",
       "      <td>福仕达鸿达</td>\n",
       "      <td>1100</td>\n",
       "      <td>10</td>\n",
       "      <td>3836</td>\n",
       "      <td>1566</td>\n",
       "      <td>1865</td>\n",
       "      <td>2515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2515</td>\n",
       "      <td>3905x1566x1865</td>\n",
       "      <td>海马</td>\n",
       "      <td>福仕达新鸿达</td>\n",
       "      <td>1660</td>\n",
       "      <td>10</td>\n",
       "      <td>3905</td>\n",
       "      <td>1566</td>\n",
       "      <td>1865</td>\n",
       "      <td>2515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2515</td>\n",
       "      <td>3905x1566x1865</td>\n",
       "      <td>海马</td>\n",
       "      <td>福仕达新鸿达</td>\n",
       "      <td></td>\n",
       "      <td>4</td>\n",
       "      <td>3905</td>\n",
       "      <td>1566</td>\n",
       "      <td>1865</td>\n",
       "      <td>2515</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2560</td>\n",
       "      <td>4195x1765x1637</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S5青春版</td>\n",
       "      <td>1258</td>\n",
       "      <td>6</td>\n",
       "      <td>4195</td>\n",
       "      <td>1765</td>\n",
       "      <td>1637</td>\n",
       "      <td>2560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2560</td>\n",
       "      <td>4195x1765x1637</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S5青春版</td>\n",
       "      <td>1321</td>\n",
       "      <td>5</td>\n",
       "      <td>4195</td>\n",
       "      <td>1765</td>\n",
       "      <td>1637</td>\n",
       "      <td>2560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2600</td>\n",
       "      <td>4545x1737x1495</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马E3</td>\n",
       "      <td>1390</td>\n",
       "      <td>1</td>\n",
       "      <td>4545</td>\n",
       "      <td>1737</td>\n",
       "      <td>1495</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2600</td>\n",
       "      <td>4545x1737x1495</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M3</td>\n",
       "      <td>1140</td>\n",
       "      <td>19</td>\n",
       "      <td>4545</td>\n",
       "      <td>1737</td>\n",
       "      <td>1495</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2600</td>\n",
       "      <td>4545x1737x1495</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M3</td>\n",
       "      <td>1210</td>\n",
       "      <td>10</td>\n",
       "      <td>4545</td>\n",
       "      <td>1737</td>\n",
       "      <td>1495</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2600</td>\n",
       "      <td>4553x1737x1495</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M3</td>\n",
       "      <td>1140</td>\n",
       "      <td>8</td>\n",
       "      <td>4553</td>\n",
       "      <td>1737</td>\n",
       "      <td>1495</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2600</td>\n",
       "      <td>4553x1737x1495</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M3</td>\n",
       "      <td>1210</td>\n",
       "      <td>4</td>\n",
       "      <td>4553</td>\n",
       "      <td>1737</td>\n",
       "      <td>1495</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2600</td>\n",
       "      <td>4553x1737x1510</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马@3</td>\n",
       "      <td>1431</td>\n",
       "      <td>2</td>\n",
       "      <td>4553</td>\n",
       "      <td>1737</td>\n",
       "      <td>1510</td>\n",
       "      <td>2600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>1325</td>\n",
       "      <td>6</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>2607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2607</td>\n",
       "      <td>4342x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>欢动</td>\n",
       "      <td>1340</td>\n",
       "      <td>6</td>\n",
       "      <td>4342</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>2607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2607</td>\n",
       "      <td>4466x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马3</td>\n",
       "      <td>1290</td>\n",
       "      <td>4</td>\n",
       "      <td>4466</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>2607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2607</td>\n",
       "      <td>4466x1730x1474</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马3</td>\n",
       "      <td>1330</td>\n",
       "      <td>4</td>\n",
       "      <td>4466</td>\n",
       "      <td>1730</td>\n",
       "      <td>1474</td>\n",
       "      <td>2607</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2610</td>\n",
       "      <td>4365x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>马自达323</td>\n",
       "      <td>1170</td>\n",
       "      <td>2</td>\n",
       "      <td>4365</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2610</td>\n",
       "      <td>4365x1705x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1157</td>\n",
       "      <td>1</td>\n",
       "      <td>4365</td>\n",
       "      <td>1705</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2610</td>\n",
       "      <td>4365x1705x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1170</td>\n",
       "      <td>4</td>\n",
       "      <td>4365</td>\n",
       "      <td>1705</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2610</td>\n",
       "      <td>4365x1705x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1205</td>\n",
       "      <td>9</td>\n",
       "      <td>4365</td>\n",
       "      <td>1705</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2610</td>\n",
       "      <td>4464x1695x1425</td>\n",
       "      <td>海马</td>\n",
       "      <td>海福星</td>\n",
       "      <td>1100</td>\n",
       "      <td>14</td>\n",
       "      <td>4464</td>\n",
       "      <td>1695</td>\n",
       "      <td>1425</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1180</td>\n",
       "      <td>3</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1695x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1205</td>\n",
       "      <td>2</td>\n",
       "      <td>4466</td>\n",
       "      <td>1695</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1705x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>4466</td>\n",
       "      <td>1705</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1705x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1175</td>\n",
       "      <td>1</td>\n",
       "      <td>4466</td>\n",
       "      <td>1705</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1705x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1180</td>\n",
       "      <td>4</td>\n",
       "      <td>4466</td>\n",
       "      <td>1705</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2610</td>\n",
       "      <td>4466x1705x1410</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1205</td>\n",
       "      <td>6</td>\n",
       "      <td>4466</td>\n",
       "      <td>1705</td>\n",
       "      <td>1410</td>\n",
       "      <td>2610</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2619</td>\n",
       "      <td>4421x1830x1740</td>\n",
       "      <td>海马</td>\n",
       "      <td>骑士</td>\n",
       "      <td>1495</td>\n",
       "      <td>5</td>\n",
       "      <td>4421</td>\n",
       "      <td>1830</td>\n",
       "      <td>1740</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2619</td>\n",
       "      <td>4456x1830x1740</td>\n",
       "      <td>海马</td>\n",
       "      <td>骑士</td>\n",
       "      <td>1435</td>\n",
       "      <td>5</td>\n",
       "      <td>4456</td>\n",
       "      <td>1830</td>\n",
       "      <td>1740</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2619</td>\n",
       "      <td>4456x1830x1740</td>\n",
       "      <td>海马</td>\n",
       "      <td>骑士</td>\n",
       "      <td>1480</td>\n",
       "      <td>5</td>\n",
       "      <td>4456</td>\n",
       "      <td>1830</td>\n",
       "      <td>1740</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2619</td>\n",
       "      <td>4456x1830x1740</td>\n",
       "      <td>海马</td>\n",
       "      <td>骑士</td>\n",
       "      <td>1495</td>\n",
       "      <td>10</td>\n",
       "      <td>4456</td>\n",
       "      <td>1830</td>\n",
       "      <td>1740</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2619</td>\n",
       "      <td>4480x1860x1715</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S7</td>\n",
       "      <td>1510</td>\n",
       "      <td>2</td>\n",
       "      <td>4480</td>\n",
       "      <td>1860</td>\n",
       "      <td>1715</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2619</td>\n",
       "      <td>4480x1860x1715</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S7</td>\n",
       "      <td>1545</td>\n",
       "      <td>2</td>\n",
       "      <td>4480</td>\n",
       "      <td>1860</td>\n",
       "      <td>1715</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2619</td>\n",
       "      <td>4498x1830x1730</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S7</td>\n",
       "      <td>1510</td>\n",
       "      <td>7</td>\n",
       "      <td>4498</td>\n",
       "      <td>1830</td>\n",
       "      <td>1730</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2619</td>\n",
       "      <td>4498x1830x1730</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S7</td>\n",
       "      <td>1545</td>\n",
       "      <td>6</td>\n",
       "      <td>4498</td>\n",
       "      <td>1830</td>\n",
       "      <td>1730</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2619</td>\n",
       "      <td>4530x1830x1730</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S7</td>\n",
       "      <td>1510</td>\n",
       "      <td>3</td>\n",
       "      <td>4530</td>\n",
       "      <td>1830</td>\n",
       "      <td>1730</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2619</td>\n",
       "      <td>4530x1830x1730</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S7</td>\n",
       "      <td>1545</td>\n",
       "      <td>4</td>\n",
       "      <td>4530</td>\n",
       "      <td>1830</td>\n",
       "      <td>1730</td>\n",
       "      <td>2619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2630</td>\n",
       "      <td>4358x1823x1630</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S5</td>\n",
       "      <td>1380</td>\n",
       "      <td>7</td>\n",
       "      <td>4358</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>2630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2630</td>\n",
       "      <td>4358x1823x1630</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S5</td>\n",
       "      <td>1432</td>\n",
       "      <td>7</td>\n",
       "      <td>4358</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>2630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2630</td>\n",
       "      <td>4358x1823x1630</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马S5</td>\n",
       "      <td>1435</td>\n",
       "      <td>8</td>\n",
       "      <td>4358</td>\n",
       "      <td>1823</td>\n",
       "      <td>1630</td>\n",
       "      <td>2630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>2670</td>\n",
       "      <td>4430x1718x1609</td>\n",
       "      <td>海马</td>\n",
       "      <td>普力马</td>\n",
       "      <td>1350</td>\n",
       "      <td>20</td>\n",
       "      <td>4430</td>\n",
       "      <td>1718</td>\n",
       "      <td>1609</td>\n",
       "      <td>2670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>2670</td>\n",
       "      <td>4430x1718x1609</td>\n",
       "      <td>海马</td>\n",
       "      <td>普力马</td>\n",
       "      <td>1370</td>\n",
       "      <td>20</td>\n",
       "      <td>4430</td>\n",
       "      <td>1718</td>\n",
       "      <td>1609</td>\n",
       "      <td>2670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1325</td>\n",
       "      <td>19</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>2685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1350</td>\n",
       "      <td>9</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>2685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>2685</td>\n",
       "      <td>4698x1806x1477</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F5</td>\n",
       "      <td>1390</td>\n",
       "      <td>3</td>\n",
       "      <td>4698</td>\n",
       "      <td>1806</td>\n",
       "      <td>1477</td>\n",
       "      <td>2685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>2715</td>\n",
       "      <td>4575x1680x1950</td>\n",
       "      <td>海马</td>\n",
       "      <td>福仕达福卡</td>\n",
       "      <td>1110</td>\n",
       "      <td>2</td>\n",
       "      <td>4575</td>\n",
       "      <td>1680</td>\n",
       "      <td>1950</td>\n",
       "      <td>2715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>2715</td>\n",
       "      <td>4575x1680x1950</td>\n",
       "      <td>海马</td>\n",
       "      <td>福仕达福卡</td>\n",
       "      <td>1170</td>\n",
       "      <td>2</td>\n",
       "      <td>4575</td>\n",
       "      <td>1680</td>\n",
       "      <td>1950</td>\n",
       "      <td>2715</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>1330</td>\n",
       "      <td>4</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>2730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>2730</td>\n",
       "      <td>4700x1802x1478</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M6</td>\n",
       "      <td>1435</td>\n",
       "      <td>10</td>\n",
       "      <td>4700</td>\n",
       "      <td>1802</td>\n",
       "      <td>1478</td>\n",
       "      <td>2730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>2800</td>\n",
       "      <td>4750x1800x1695</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F7</td>\n",
       "      <td>1560</td>\n",
       "      <td>3</td>\n",
       "      <td>4750</td>\n",
       "      <td>1800</td>\n",
       "      <td>1695</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>2800</td>\n",
       "      <td>4750x1800x1695</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F7</td>\n",
       "      <td>1585</td>\n",
       "      <td>5</td>\n",
       "      <td>4750</td>\n",
       "      <td>1800</td>\n",
       "      <td>1695</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>2800</td>\n",
       "      <td>4770x1800x1695</td>\n",
       "      <td>海马</td>\n",
       "      <td>福美来F7</td>\n",
       "      <td>1585</td>\n",
       "      <td>5</td>\n",
       "      <td>4770</td>\n",
       "      <td>1800</td>\n",
       "      <td>1695</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>2800</td>\n",
       "      <td>4845x1830x1475</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M8</td>\n",
       "      <td>1480</td>\n",
       "      <td>3</td>\n",
       "      <td>4845</td>\n",
       "      <td>1830</td>\n",
       "      <td>1475</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>2800</td>\n",
       "      <td>4845x1830x1475</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M8</td>\n",
       "      <td>1525</td>\n",
       "      <td>3</td>\n",
       "      <td>4845</td>\n",
       "      <td>1830</td>\n",
       "      <td>1475</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>2800</td>\n",
       "      <td>4845x1830x1475</td>\n",
       "      <td>海马</td>\n",
       "      <td>海马M8</td>\n",
       "      <td>1550</td>\n",
       "      <td>6</td>\n",
       "      <td>4845</td>\n",
       "      <td>1830</td>\n",
       "      <td>1475</td>\n",
       "      <td>2800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>2900</td>\n",
       "      <td>4855x1680x1950</td>\n",
       "      <td>海马</td>\n",
       "      <td>福仕达福卡</td>\n",
       "      <td>1125</td>\n",
       "      <td>2</td>\n",
       "      <td>4855</td>\n",
       "      <td>1680</td>\n",
       "      <td>1950</td>\n",
       "      <td>2900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>2900</td>\n",
       "      <td>4855x1680x1950</td>\n",
       "      <td>海马</td>\n",
       "      <td>福仕达福卡</td>\n",
       "      <td>1180</td>\n",
       "      <td>2</td>\n",
       "      <td>4855</td>\n",
       "      <td>1680</td>\n",
       "      <td>1950</td>\n",
       "      <td>2900</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>68 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   轴距[mm]       长×宽×高[mm] brand    style curb_weight  factory car_length  \\\n",
       "0    2332  3590x1540x1486    海马     海马王子         895        6       3590   \n",
       "1    2332  3590x1540x1518    海马     海马王子         895        6       3590   \n",
       "2    2333  3662x1540x1495    海马     海马爱尚         888        6       3662   \n",
       "3    2333  3662x1540x1503    海马     海马爱尚         888        2       3662   \n",
       "4    2515  3836x1566x1865    海马    福仕达鸿达        1100       10       3836   \n",
       "5    2515  3905x1566x1865    海马   福仕达新鸿达        1660       10       3905   \n",
       "6    2515  3905x1566x1865    海马   福仕达新鸿达                    4       3905   \n",
       "7    2560  4195x1765x1637    海马  海马S5青春版        1258        6       4195   \n",
       "8    2560  4195x1765x1637    海马  海马S5青春版        1321        5       4195   \n",
       "9    2600  4545x1737x1495    海马     海马E3        1390        1       4545   \n",
       "10   2600  4545x1737x1495    海马     海马M3        1140       19       4545   \n",
       "11   2600  4545x1737x1495    海马     海马M3        1210       10       4545   \n",
       "12   2600  4553x1737x1495    海马     海马M3        1140        8       4553   \n",
       "13   2600  4553x1737x1495    海马     海马M3        1210        4       4553   \n",
       "14   2600  4553x1737x1510    海马     海马@3        1431        2       4553   \n",
       "15   2607  4342x1730x1474    海马       欢动        1325        6       4342   \n",
       "16   2607  4342x1730x1474    海马       欢动        1340        6       4342   \n",
       "17   2607  4466x1730x1474    海马      海马3        1290        4       4466   \n",
       "18   2607  4466x1730x1474    海马      海马3        1330        4       4466   \n",
       "19   2610  4365x1695x1410    海马   马自达323        1170        2       4365   \n",
       "20   2610  4365x1705x1410    海马    福美来F5        1157        1       4365   \n",
       "21   2610  4365x1705x1410    海马    福美来F5        1170        4       4365   \n",
       "22   2610  4365x1705x1410    海马    福美来F5        1205        9       4365   \n",
       "23   2610  4464x1695x1425    海马      海福星        1100       14       4464   \n",
       "24   2610  4466x1695x1410    海马    福美来F5        1180        3       4466   \n",
       "25   2610  4466x1695x1410    海马    福美来F5        1205        2       4466   \n",
       "26   2610  4466x1705x1410    海马    福美来F5           0        4       4466   \n",
       "27   2610  4466x1705x1410    海马    福美来F5        1175        1       4466   \n",
       "28   2610  4466x1705x1410    海马    福美来F5        1180        4       4466   \n",
       "29   2610  4466x1705x1410    海马    福美来F5        1205        6       4466   \n",
       "..    ...             ...   ...      ...         ...      ...        ...   \n",
       "38   2619  4421x1830x1740    海马       骑士        1495        5       4421   \n",
       "39   2619  4456x1830x1740    海马       骑士        1435        5       4456   \n",
       "40   2619  4456x1830x1740    海马       骑士        1480        5       4456   \n",
       "41   2619  4456x1830x1740    海马       骑士        1495       10       4456   \n",
       "42   2619  4480x1860x1715    海马     海马S7        1510        2       4480   \n",
       "43   2619  4480x1860x1715    海马     海马S7        1545        2       4480   \n",
       "44   2619  4498x1830x1730    海马     海马S7        1510        7       4498   \n",
       "45   2619  4498x1830x1730    海马     海马S7        1545        6       4498   \n",
       "46   2619  4530x1830x1730    海马     海马S7        1510        3       4530   \n",
       "47   2619  4530x1830x1730    海马     海马S7        1545        4       4530   \n",
       "48   2630  4358x1823x1630    海马     海马S5        1380        7       4358   \n",
       "49   2630  4358x1823x1630    海马     海马S5        1432        7       4358   \n",
       "50   2630  4358x1823x1630    海马     海马S5        1435        8       4358   \n",
       "51   2670  4430x1718x1609    海马      普力马        1350       20       4430   \n",
       "52   2670  4430x1718x1609    海马      普力马        1370       20       4430   \n",
       "53   2685  4698x1806x1477    海马    福美来F5        1325       19       4698   \n",
       "54   2685  4698x1806x1477    海马    福美来F5        1350        9       4698   \n",
       "55   2685  4698x1806x1477    海马    福美来F5        1390        3       4698   \n",
       "56   2715  4575x1680x1950    海马    福仕达福卡        1110        2       4575   \n",
       "57   2715  4575x1680x1950    海马    福仕达福卡        1170        2       4575   \n",
       "58   2730  4700x1802x1478    海马     海马M6        1330        4       4700   \n",
       "59   2730  4700x1802x1478    海马     海马M6        1435       10       4700   \n",
       "60   2800  4750x1800x1695    海马    福美来F7        1560        3       4750   \n",
       "61   2800  4750x1800x1695    海马    福美来F7        1585        5       4750   \n",
       "62   2800  4770x1800x1695    海马    福美来F7        1585        5       4770   \n",
       "63   2800  4845x1830x1475    海马     海马M8        1480        3       4845   \n",
       "64   2800  4845x1830x1475    海马     海马M8        1525        3       4845   \n",
       "65   2800  4845x1830x1475    海马     海马M8        1550        6       4845   \n",
       "66   2900  4855x1680x1950    海马    福仕达福卡        1125        2       4855   \n",
       "67   2900  4855x1680x1950    海马    福仕达福卡        1180        2       4855   \n",
       "\n",
       "   car_width car_height Wheelbase  \n",
       "0       1540       1486      2332  \n",
       "1       1540       1518      2332  \n",
       "2       1540       1495      2333  \n",
       "3       1540       1503      2333  \n",
       "4       1566       1865      2515  \n",
       "5       1566       1865      2515  \n",
       "6       1566       1865      2515  \n",
       "7       1765       1637      2560  \n",
       "8       1765       1637      2560  \n",
       "9       1737       1495      2600  \n",
       "10      1737       1495      2600  \n",
       "11      1737       1495      2600  \n",
       "12      1737       1495      2600  \n",
       "13      1737       1495      2600  \n",
       "14      1737       1510      2600  \n",
       "15      1730       1474      2607  \n",
       "16      1730       1474      2607  \n",
       "17      1730       1474      2607  \n",
       "18      1730       1474      2607  \n",
       "19      1695       1410      2610  \n",
       "20      1705       1410      2610  \n",
       "21      1705       1410      2610  \n",
       "22      1705       1410      2610  \n",
       "23      1695       1425      2610  \n",
       "24      1695       1410      2610  \n",
       "25      1695       1410      2610  \n",
       "26      1705       1410      2610  \n",
       "27      1705       1410      2610  \n",
       "28      1705       1410      2610  \n",
       "29      1705       1410      2610  \n",
       "..       ...        ...       ...  \n",
       "38      1830       1740      2619  \n",
       "39      1830       1740      2619  \n",
       "40      1830       1740      2619  \n",
       "41      1830       1740      2619  \n",
       "42      1860       1715      2619  \n",
       "43      1860       1715      2619  \n",
       "44      1830       1730      2619  \n",
       "45      1830       1730      2619  \n",
       "46      1830       1730      2619  \n",
       "47      1830       1730      2619  \n",
       "48      1823       1630      2630  \n",
       "49      1823       1630      2630  \n",
       "50      1823       1630      2630  \n",
       "51      1718       1609      2670  \n",
       "52      1718       1609      2670  \n",
       "53      1806       1477      2685  \n",
       "54      1806       1477      2685  \n",
       "55      1806       1477      2685  \n",
       "56      1680       1950      2715  \n",
       "57      1680       1950      2715  \n",
       "58      1802       1478      2730  \n",
       "59      1802       1478      2730  \n",
       "60      1800       1695      2800  \n",
       "61      1800       1695      2800  \n",
       "62      1800       1695      2800  \n",
       "63      1830       1475      2800  \n",
       "64      1830       1475      2800  \n",
       "65      1830       1475      2800  \n",
       "66      1680       1950      2900  \n",
       "67      1680       1950      2900  \n",
       "\n",
       "[68 rows x 10 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "LSG_price"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
